package com.gimi.test_jpa.com.gimi.entity.customer;


import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import org.hibernate.annotations.GenericGenerator;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.*;
import java.util.Date;

@Data
@Entity
@Table(name = "cus_contact_info")
@TableName("cus_contact_info")
public class CustomerContactInfoEntity {
    @Id
    @GenericGenerator(name = "systemUUID", strategy = "uuid")
    @GeneratedValue(generator = "systemUUID")
    @Column(name = "cus_contact_id", columnDefinition = " varchar(36) not null comment '客户联系信息ID'")
    @TableId
    private String cusContactId;

    @Column(name = "cus_id",columnDefinition = "varchar(36) comment '客户ID'")
    private String cusId;

    @Column(name = "cus_phone",columnDefinition = "varchar(20) comment '电话号码'")
    private String cusPhone;

    @Column(name = "cus_telphone",columnDefinition = "varchar(20) comment '座机或者备用手机号'")
    private String cusTelphone;

    @Column(name = "cus_qq",columnDefinition = "varchar(20) comment 'qq'")
    private String cusQq;

    @Column(name = "cus_wechat",columnDefinition = "varchar(70) comment '微信号码'")
    private String cusWechat;

    @Column(name = "cus_email",columnDefinition = "varchar(100) comment 'email'")
    private String cusEmail;

    @Column(name = "cus_adress",columnDefinition = "varchar(255) comment '联系地址'")
    private String cusAdress;

    @Column(name = "add_name",columnDefinition = "varchar(50) default NULL comment '添加人名称'")
    private String addName;

    @Column(name = "add_time ",columnDefinition = "datetime comment '添加时间'")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss.sss")
    private Date addTime;
}
